# -*- coding: utf-8 -*-

import pymysql


def get_conn_31():
    #爬虫数据库
    return pymysql.Connect(host='192.168.1.31',port=3306,db='yibiao',user='select',passwd='1qaz!QAZ',charset='utf8',cursorclass = pymysql.cursors.DictCursor)

def get_conn_64():
    #企查查数据库
    return  pymysql.Connect(host='192.168.1.64',port=3306,db='qcc_companies',user='root',passwd='9666',charset='utf8',cursorclass = pymysql.cursors.DictCursor)


def get_conn_33():
    #web测试环境
    return pymysql.Connect(host='192.168.1.33',port=3306,db='yibiao',user='ybData',passwd='3532Yibiao!',charset='utf8',cursorclass = pymysql.cursors.DictCursor)

def get_conn_theme_33():
    #主题数据库
    return pymysql.Connect(host='192.168.1.33',port=3306,db='theme',user='ybData',passwd='3532Yibiao!',charset='utf8',cursorclass = pymysql.cursors.DictCursor)

def get_mysql_52(dbName):
    #主题数据库
    return pymysql.Connect(host='192.168.1.52',port=3306,db=dbName,user='root',passwd='root',charset='utf8',cursorclass = pymysql.cursors.DictCursor)














